Labels:text | screenshot | menu | font OCR: Time key Time Dimension Customer Dimension Customer key Product key Product Dimension Promotion Dimension Promotion key Salesperson key Salesperson Dimension Status Dimension Status key Extended unit price Full additive: Extended cost compute gross margin by dividing Daily sales Only store daily here. Store aggregates in separate tables. Figure 2. A "good" fact table in which all of the problems in Figure 1 have been cleaned up.
